package com.jackrain.nea.fc.dl.mapper;


import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.HashMap;
import java.util.List;

@Mapper
public interface TransferReloadMapper {

    @Select("SELECT ID FROM DL_B_TRAN WHERE  STATUS = 2 AND SEND_STATUS = 1 AND MODIFIEDDATE BETWEEN #{begintime}" +
            "AND  #{endtime} and IS_ADJUST=1 AND IS_PICK='N'")
    List<HashMap> seltransfersubmit(@Param("begintime") String begintime, @Param("endtime") String endtime);

    @Select("SELECT ID FROM DL_B_TRAN WHERE  STATUS = 1 AND MODIFIEDDATE BETWEEN #{begintime}" +
            "  AND #{endtime} AND IS_ADJUST=1 AND IS_PICK='N' AND ISACTIVE='N'")
    List<HashMap> seltransfervoid(@Param("begintime") String begintime, @Param("endtime") String endtime);

    @Select("select ID from dl_b_tran where  STATUS = 1 and MODIFIEDDATE BETWEEN #{begintime}" +
            "  and #{endtime} and is_adjust=1 and is_pick='N' and STATUSTIME > #{statustime}")
    List<HashMap> seltransferunsubmit(@Param("begintime") String begintime, @Param("endtime") String endtime, @Param("statustime") String statustime);

}
